data integrity and normalization overview